/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost
 Source Database       : test_1

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 08/09/2017 11:29:33 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `tb_order`
-- ----------------------------
DROP TABLE IF EXISTS `tb_order_test`;
CREATE TABLE `tb_order_test` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ad_position_id` varchar(255) DEFAULT NULL,
  `admin_amount` double DEFAULT NULL,
  `ali_wangwang` varchar(255) DEFAULT NULL,
  `category_name` varchar(255) DEFAULT NULL,
  `click_time` datetime DEFAULT NULL,
  `commission_amount` double DEFAULT NULL,
  `commission_rate` double DEFAULT NULL,
  `commodity_id` varchar(255) DEFAULT NULL,
  `commodity_info` varchar(255) DEFAULT NULL,
  `commodity_num` int(11) DEFAULT NULL,
  `commodity_price` double DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `effect_prediction` double DEFAULT NULL,
  `estimated_income` double DEFAULT NULL,
  `grand_parent_amount` double DEFAULT NULL,
  `grand_parent_id` bigint(20) DEFAULT NULL,
  `income_ratio` double DEFAULT NULL,
  `media_id` varchar(255) DEFAULT NULL,
  `media_name` varchar(255) DEFAULT NULL,
  `order_number` varchar(255) DEFAULT NULL,
  `order_status` varchar(255) DEFAULT NULL,
  `order_type` varchar(255) DEFAULT NULL,
  `parent_amount` double DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `payment` double DEFAULT NULL,
  `pid` varchar(255) DEFAULT NULL,
  `pid_name` varchar(255) DEFAULT NULL,
  `promoter_amount` double DEFAULT NULL,
  `promoter_id` bigint(20) DEFAULT NULL,
  `settlement_amount` double DEFAULT NULL,
  `settlement_time` varchar(255) DEFAULT NULL,
  `share_ratio` double DEFAULT NULL,
  `shop` varchar(255) DEFAULT NULL,
  `subsidy_amount` double DEFAULT NULL,
  `subsidy_ratio` double DEFAULT NULL,
  `subsidy_type` varchar(255) DEFAULT NULL,
  `third_party` varchar(255) DEFAULT NULL,
  `transaction_platform` varchar(255) DEFAULT NULL,
  `domain_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- BEGIN;
-- INSERT INTO `tb_admin` (create_time, domain_id, is_delete, modified_time, name, password, phone, token, we_chat) VALUES (NOW(), 8, null, null, 'admin', 'e10adc3949ba59abbe56e057f20f883e', null, null, null);
-- COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
